package com.duowei.diandan.db.entry;

import android.arch.persistence.room.Entity;
import android.arch.persistence.room.PrimaryKey;

/**
 * 微信服务器地址设置(只存一行数据)
 */
@Entity
public class Wxfwqdz {
    @PrimaryKey(autoGenerate = true)
    private long id;

    /** 服务器ip */
    private String sip; //VARCHAR(100),
    /** 微信公众号 */
    private String wxgzh; //VARCHAR(100),
    /** 原始id */
    private String ysid; //VARCHAR(100),
    /** 分店编号 */
    private String bmbh; //VARCHAR(10),
    private String storeid; //VARCHAR(50),
    private String weid; //VARCHAR(50),
    private String by1; //VARCHAR(100),
    private String by2; //VARCHAR(100),
    private String by3; //VARCHAR(100)

    public Wxfwqdz() {
    }

    public long getId() {
        return id;
    }

    public void setId(long id) {
        this.id = id;
    }

    public String getSip() {
        return this.sip;
    }

    public String getAndroidSip() {
        if (this.sip != null) {
            return "android" + this.sip;
        } else {
            return null;
        }
    }

    public void setSip(String sip) {
        this.sip = sip;
    }

    public String getWxgzh() {
        return wxgzh;
    }

    public void setWxgzh(String wxgzh) {
        this.wxgzh = wxgzh;
    }

    public String getYsid() {
        return ysid;
    }

    public void setYsid(String ysid) {
        this.ysid = ysid;
    }

    public String getBmbh() {
        return bmbh;
    }

    public void setBmbh(String bmbh) {
        this.bmbh = bmbh;
    }

    public String getStoreid() {
        return storeid;
    }

    public void setStoreid(String storeid) {
        this.storeid = storeid;
    }

    public String getWeid() {
        return weid;
    }

    public void setWeid(String weid) {
        this.weid = weid;
    }

    public String getBy1() {
        return by1;
    }

    public void setBy1(String by1) {
        this.by1 = by1;
    }

    public String getBy2() {
        return by2;
    }

    public void setBy2(String by2) {
        this.by2 = by2;
    }

    public String getBy3() {
        return by3;
    }

    public void setBy3(String by3) {
        this.by3 = by3;
    }

    public static String querySql() {
        return "select sip, wxgzh, ysid, bmbh, storeid, weid, by1, by2, by3 from WXFWQDZ|";
    }
}
